About Vijan Computers | Best Computer Institute in Gurgaon

Advance Excel Course | Vijan Computers

Course Overview

The Advanced Excel Course at Vijan Computers is designed to help students and professionals master Excel for real-world business, MIS reporting, and data analysis. This course focuses on practical usage of Excel functions, dashboards, automation, and advanced tools used in offices today.

What You Will Learn

Advanced Excel formulas & functions
Data analysis using Pivot Tables
Dynamic dashboards & reports
Data validation & automation techniques
Real-time office & business use cases

Tools & Software Covered

Microsoft Excel (Latest Version)
Excel Power Query
Excel Power Pivot
Excel Charts & Dashboard Tools

Course Curriculum

Module 1: Excel Fundamentals (Revision)

Excel Interface & Shortcuts
Cell Formatting & Styles
Basic Formulas & Functions

Module 2: Advanced Functions

IF, IFS, Nested IF
VLOOKUP, HLOOKUP, XLOOKUP
INDEX, MATCH
TEXT, DATE & LOGICAL Functions

Module 3: Data Analysis & Pivot Tables

Sorting & Filtering Data
Pivot Tables & Pivot Charts
Slicers & Timeline

Module 4: Dashboards & Reporting

Interactive Dashboards
Charts & Graphs
Conditional Formatting

Module 5: Automation & Advanced Tools

Data Validation
Macros (Introduction)
Power Query Basics

Duration & Eligibility

Duration: 1.5 – 2 Months

Eligibility: Students, Job Seekers, Working Professionals

Course Fees & Schedule

Batch Type	Duration	Mode	Fees
Regular Batch	1.5 Months	Offline	₹2,000
Weekend Batch	3 Months	Offline	₹3,000

Vijan Computers

Advanced Excel Course